﻿
CREATE PROCEDURE [dbo].[OPM_ReturnOrderDetail_Update]
(
	@Id  int,
	@ReturnOrderId  int,
	@ProductNumber  nvarchar(50),
	@ProductQty  int,
	@ReturnTypeId  int,
	@ReturnReasonXML  xml,
	@OtherReasonChecked bit,
	@OtherReasonContent nvarchar(4000),
	@UpdatedBy int
)

AS

    UPDATE dbo.[OPM_ReturnOrderDetail]
	SET 
		[ReturnOrderId] = @ReturnOrderId,
		[ProductNumber] = @ProductNumber,
		[ProductQty] = @ProductQty,
		[ReturnTypeId] = @ReturnTypeId,
		[ReturnReasonXML] = @ReturnReasonXML,
		[OtherReasonChecked] = @OtherReasonChecked,
		[OtherReasonContent] = @OtherReasonContent,
		[UpdatedBy] = @UpdatedBy,
		[UpdatedOn] = getdate()
	WHERE [Id] = @Id